SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO



ALTER    view v_td_depot
as
select d.*, f.FI_FilNM,a.name areaname from td_depot d
left join td_Filiale f on d.filid = f.FI_FilId
left join td_area a on d.areaid=a.id



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

